package com.weimall.pojo;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class CzdZbExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CzdZbExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andLxbmIsNull() {
            addCriterion("LXBM is null");
            return (Criteria) this;
        }

        public Criteria andLxbmIsNotNull() {
            addCriterion("LXBM is not null");
            return (Criteria) this;
        }

        public Criteria andLxbmEqualTo(String value) {
            addCriterion("LXBM =", value, "lxbm");
            return (Criteria) this;
        }

        public Criteria andLxbmNotEqualTo(String value) {
            addCriterion("LXBM <>", value, "lxbm");
            return (Criteria) this;
        }

        public Criteria andLxbmGreaterThan(String value) {
            addCriterion("LXBM >", value, "lxbm");
            return (Criteria) this;
        }

        public Criteria andLxbmGreaterThanOrEqualTo(String value) {
            addCriterion("LXBM >=", value, "lxbm");
            return (Criteria) this;
        }

        public Criteria andLxbmLessThan(String value) {
            addCriterion("LXBM <", value, "lxbm");
            return (Criteria) this;
        }

        public Criteria andLxbmLessThanOrEqualTo(String value) {
            addCriterion("LXBM <=", value, "lxbm");
            return (Criteria) this;
        }

        public Criteria andLxbmLike(String value) {
            addCriterion("LXBM like", value, "lxbm");
            return (Criteria) this;
        }

        public Criteria andLxbmNotLike(String value) {
            addCriterion("LXBM not like", value, "lxbm");
            return (Criteria) this;
        }

        public Criteria andLxbmIn(List<String> values) {
            addCriterion("LXBM in", values, "lxbm");
            return (Criteria) this;
        }

        public Criteria andLxbmNotIn(List<String> values) {
            addCriterion("LXBM not in", values, "lxbm");
            return (Criteria) this;
        }

        public Criteria andLxbmBetween(String value1, String value2) {
            addCriterion("LXBM between", value1, value2, "lxbm");
            return (Criteria) this;
        }

        public Criteria andLxbmNotBetween(String value1, String value2) {
            addCriterion("LXBM not between", value1, value2, "lxbm");
            return (Criteria) this;
        }

        public Criteria andLxmcIsNull() {
            addCriterion("LXMC is null");
            return (Criteria) this;
        }

        public Criteria andLxmcIsNotNull() {
            addCriterion("LXMC is not null");
            return (Criteria) this;
        }

        public Criteria andLxmcEqualTo(String value) {
            addCriterion("LXMC =", value, "lxmc");
            return (Criteria) this;
        }

        public Criteria andLxmcNotEqualTo(String value) {
            addCriterion("LXMC <>", value, "lxmc");
            return (Criteria) this;
        }

        public Criteria andLxmcGreaterThan(String value) {
            addCriterion("LXMC >", value, "lxmc");
            return (Criteria) this;
        }

        public Criteria andLxmcGreaterThanOrEqualTo(String value) {
            addCriterion("LXMC >=", value, "lxmc");
            return (Criteria) this;
        }

        public Criteria andLxmcLessThan(String value) {
            addCriterion("LXMC <", value, "lxmc");
            return (Criteria) this;
        }

        public Criteria andLxmcLessThanOrEqualTo(String value) {
            addCriterion("LXMC <=", value, "lxmc");
            return (Criteria) this;
        }

        public Criteria andLxmcLike(String value) {
            addCriterion("LXMC like", value, "lxmc");
            return (Criteria) this;
        }

        public Criteria andLxmcNotLike(String value) {
            addCriterion("LXMC not like", value, "lxmc");
            return (Criteria) this;
        }

        public Criteria andLxmcIn(List<String> values) {
            addCriterion("LXMC in", values, "lxmc");
            return (Criteria) this;
        }

        public Criteria andLxmcNotIn(List<String> values) {
            addCriterion("LXMC not in", values, "lxmc");
            return (Criteria) this;
        }

        public Criteria andLxmcBetween(String value1, String value2) {
            addCriterion("LXMC between", value1, value2, "lxmc");
            return (Criteria) this;
        }

        public Criteria andLxmcNotBetween(String value1, String value2) {
            addCriterion("LXMC not between", value1, value2, "lxmc");
            return (Criteria) this;
        }

        public Criteria andRqIsNull() {
            addCriterion("RQ is null");
            return (Criteria) this;
        }

        public Criteria andRqIsNotNull() {
            addCriterion("RQ is not null");
            return (Criteria) this;
        }

        public Criteria andRqEqualTo(Date value) {
            addCriterion("RQ =", value, "rq");
            return (Criteria) this;
        }

        public Criteria andRqNotEqualTo(Date value) {
            addCriterion("RQ <>", value, "rq");
            return (Criteria) this;
        }

        public Criteria andRqGreaterThan(Date value) {
            addCriterion("RQ >", value, "rq");
            return (Criteria) this;
        }

        public Criteria andRqGreaterThanOrEqualTo(Date value) {
            addCriterion("RQ >=", value, "rq");
            return (Criteria) this;
        }

        public Criteria andRqLessThan(Date value) {
            addCriterion("RQ <", value, "rq");
            return (Criteria) this;
        }

        public Criteria andRqLessThanOrEqualTo(Date value) {
            addCriterion("RQ <=", value, "rq");
            return (Criteria) this;
        }

        public Criteria andRqIn(List<Date> values) {
            addCriterion("RQ in", values, "rq");
            return (Criteria) this;
        }

        public Criteria andRqNotIn(List<Date> values) {
            addCriterion("RQ not in", values, "rq");
            return (Criteria) this;
        }

        public Criteria andRqBetween(Date value1, Date value2) {
            addCriterion("RQ between", value1, value2, "rq");
            return (Criteria) this;
        }

        public Criteria andRqNotBetween(Date value1, Date value2) {
            addCriterion("RQ not between", value1, value2, "rq");
            return (Criteria) this;
        }

        public Criteria andDwbmIsNull() {
            addCriterion("DWBM is null");
            return (Criteria) this;
        }

        public Criteria andDwbmIsNotNull() {
            addCriterion("DWBM is not null");
            return (Criteria) this;
        }

        public Criteria andDwbmEqualTo(String value) {
            addCriterion("DWBM =", value, "dwbm");
            return (Criteria) this;
        }

        public Criteria andDwbmNotEqualTo(String value) {
            addCriterion("DWBM <>", value, "dwbm");
            return (Criteria) this;
        }

        public Criteria andDwbmGreaterThan(String value) {
            addCriterion("DWBM >", value, "dwbm");
            return (Criteria) this;
        }

        public Criteria andDwbmGreaterThanOrEqualTo(String value) {
            addCriterion("DWBM >=", value, "dwbm");
            return (Criteria) this;
        }

        public Criteria andDwbmLessThan(String value) {
            addCriterion("DWBM <", value, "dwbm");
            return (Criteria) this;
        }

        public Criteria andDwbmLessThanOrEqualTo(String value) {
            addCriterion("DWBM <=", value, "dwbm");
            return (Criteria) this;
        }

        public Criteria andDwbmLike(String value) {
            addCriterion("DWBM like", value, "dwbm");
            return (Criteria) this;
        }

        public Criteria andDwbmNotLike(String value) {
            addCriterion("DWBM not like", value, "dwbm");
            return (Criteria) this;
        }

        public Criteria andDwbmIn(List<String> values) {
            addCriterion("DWBM in", values, "dwbm");
            return (Criteria) this;
        }

        public Criteria andDwbmNotIn(List<String> values) {
            addCriterion("DWBM not in", values, "dwbm");
            return (Criteria) this;
        }

        public Criteria andDwbmBetween(String value1, String value2) {
            addCriterion("DWBM between", value1, value2, "dwbm");
            return (Criteria) this;
        }

        public Criteria andDwbmNotBetween(String value1, String value2) {
            addCriterion("DWBM not between", value1, value2, "dwbm");
            return (Criteria) this;
        }

        public Criteria andDwmcIsNull() {
            addCriterion("DWMC is null");
            return (Criteria) this;
        }

        public Criteria andDwmcIsNotNull() {
            addCriterion("DWMC is not null");
            return (Criteria) this;
        }

        public Criteria andDwmcEqualTo(String value) {
            addCriterion("DWMC =", value, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcNotEqualTo(String value) {
            addCriterion("DWMC <>", value, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcGreaterThan(String value) {
            addCriterion("DWMC >", value, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcGreaterThanOrEqualTo(String value) {
            addCriterion("DWMC >=", value, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcLessThan(String value) {
            addCriterion("DWMC <", value, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcLessThanOrEqualTo(String value) {
            addCriterion("DWMC <=", value, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcLike(String value) {
            addCriterion("DWMC like", value, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcNotLike(String value) {
            addCriterion("DWMC not like", value, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcIn(List<String> values) {
            addCriterion("DWMC in", values, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcNotIn(List<String> values) {
            addCriterion("DWMC not in", values, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcBetween(String value1, String value2) {
            addCriterion("DWMC between", value1, value2, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcNotBetween(String value1, String value2) {
            addCriterion("DWMC not between", value1, value2, "dwmc");
            return (Criteria) this;
        }

        public Criteria andJbrbmIsNull() {
            addCriterion("JBRBM is null");
            return (Criteria) this;
        }

        public Criteria andJbrbmIsNotNull() {
            addCriterion("JBRBM is not null");
            return (Criteria) this;
        }

        public Criteria andJbrbmEqualTo(String value) {
            addCriterion("JBRBM =", value, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmNotEqualTo(String value) {
            addCriterion("JBRBM <>", value, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmGreaterThan(String value) {
            addCriterion("JBRBM >", value, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmGreaterThanOrEqualTo(String value) {
            addCriterion("JBRBM >=", value, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmLessThan(String value) {
            addCriterion("JBRBM <", value, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmLessThanOrEqualTo(String value) {
            addCriterion("JBRBM <=", value, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmLike(String value) {
            addCriterion("JBRBM like", value, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmNotLike(String value) {
            addCriterion("JBRBM not like", value, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmIn(List<String> values) {
            addCriterion("JBRBM in", values, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmNotIn(List<String> values) {
            addCriterion("JBRBM not in", values, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmBetween(String value1, String value2) {
            addCriterion("JBRBM between", value1, value2, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmNotBetween(String value1, String value2) {
            addCriterion("JBRBM not between", value1, value2, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrmcIsNull() {
            addCriterion("JBRMC is null");
            return (Criteria) this;
        }

        public Criteria andJbrmcIsNotNull() {
            addCriterion("JBRMC is not null");
            return (Criteria) this;
        }

        public Criteria andJbrmcEqualTo(String value) {
            addCriterion("JBRMC =", value, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcNotEqualTo(String value) {
            addCriterion("JBRMC <>", value, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcGreaterThan(String value) {
            addCriterion("JBRMC >", value, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcGreaterThanOrEqualTo(String value) {
            addCriterion("JBRMC >=", value, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcLessThan(String value) {
            addCriterion("JBRMC <", value, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcLessThanOrEqualTo(String value) {
            addCriterion("JBRMC <=", value, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcLike(String value) {
            addCriterion("JBRMC like", value, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcNotLike(String value) {
            addCriterion("JBRMC not like", value, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcIn(List<String> values) {
            addCriterion("JBRMC in", values, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcNotIn(List<String> values) {
            addCriterion("JBRMC not in", values, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcBetween(String value1, String value2) {
            addCriterion("JBRMC between", value1, value2, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcNotBetween(String value1, String value2) {
            addCriterion("JBRMC not between", value1, value2, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andZdrIsNull() {
            addCriterion("ZDR is null");
            return (Criteria) this;
        }

        public Criteria andZdrIsNotNull() {
            addCriterion("ZDR is not null");
            return (Criteria) this;
        }

        public Criteria andZdrEqualTo(String value) {
            addCriterion("ZDR =", value, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrNotEqualTo(String value) {
            addCriterion("ZDR <>", value, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrGreaterThan(String value) {
            addCriterion("ZDR >", value, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrGreaterThanOrEqualTo(String value) {
            addCriterion("ZDR >=", value, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrLessThan(String value) {
            addCriterion("ZDR <", value, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrLessThanOrEqualTo(String value) {
            addCriterion("ZDR <=", value, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrLike(String value) {
            addCriterion("ZDR like", value, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrNotLike(String value) {
            addCriterion("ZDR not like", value, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrIn(List<String> values) {
            addCriterion("ZDR in", values, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrNotIn(List<String> values) {
            addCriterion("ZDR not in", values, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrBetween(String value1, String value2) {
            addCriterion("ZDR between", value1, value2, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrNotBetween(String value1, String value2) {
            addCriterion("ZDR not between", value1, value2, "zdr");
            return (Criteria) this;
        }

        public Criteria andShrIsNull() {
            addCriterion("SHR is null");
            return (Criteria) this;
        }

        public Criteria andShrIsNotNull() {
            addCriterion("SHR is not null");
            return (Criteria) this;
        }

        public Criteria andShrEqualTo(String value) {
            addCriterion("SHR =", value, "shr");
            return (Criteria) this;
        }

        public Criteria andShrNotEqualTo(String value) {
            addCriterion("SHR <>", value, "shr");
            return (Criteria) this;
        }

        public Criteria andShrGreaterThan(String value) {
            addCriterion("SHR >", value, "shr");
            return (Criteria) this;
        }

        public Criteria andShrGreaterThanOrEqualTo(String value) {
            addCriterion("SHR >=", value, "shr");
            return (Criteria) this;
        }

        public Criteria andShrLessThan(String value) {
            addCriterion("SHR <", value, "shr");
            return (Criteria) this;
        }

        public Criteria andShrLessThanOrEqualTo(String value) {
            addCriterion("SHR <=", value, "shr");
            return (Criteria) this;
        }

        public Criteria andShrLike(String value) {
            addCriterion("SHR like", value, "shr");
            return (Criteria) this;
        }

        public Criteria andShrNotLike(String value) {
            addCriterion("SHR not like", value, "shr");
            return (Criteria) this;
        }

        public Criteria andShrIn(List<String> values) {
            addCriterion("SHR in", values, "shr");
            return (Criteria) this;
        }

        public Criteria andShrNotIn(List<String> values) {
            addCriterion("SHR not in", values, "shr");
            return (Criteria) this;
        }

        public Criteria andShrBetween(String value1, String value2) {
            addCriterion("SHR between", value1, value2, "shr");
            return (Criteria) this;
        }

        public Criteria andShrNotBetween(String value1, String value2) {
            addCriterion("SHR not between", value1, value2, "shr");
            return (Criteria) this;
        }

        public Criteria andPzhIsNull() {
            addCriterion("PZH is null");
            return (Criteria) this;
        }

        public Criteria andPzhIsNotNull() {
            addCriterion("PZH is not null");
            return (Criteria) this;
        }

        public Criteria andPzhEqualTo(String value) {
            addCriterion("PZH =", value, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhNotEqualTo(String value) {
            addCriterion("PZH <>", value, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhGreaterThan(String value) {
            addCriterion("PZH >", value, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhGreaterThanOrEqualTo(String value) {
            addCriterion("PZH >=", value, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhLessThan(String value) {
            addCriterion("PZH <", value, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhLessThanOrEqualTo(String value) {
            addCriterion("PZH <=", value, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhLike(String value) {
            addCriterion("PZH like", value, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhNotLike(String value) {
            addCriterion("PZH not like", value, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhIn(List<String> values) {
            addCriterion("PZH in", values, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhNotIn(List<String> values) {
            addCriterion("PZH not in", values, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhBetween(String value1, String value2) {
            addCriterion("PZH between", value1, value2, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhNotBetween(String value1, String value2) {
            addCriterion("PZH not between", value1, value2, "pzh");
            return (Criteria) this;
        }

        public Criteria andJsfsbmIsNull() {
            addCriterion("JSFSBM is null");
            return (Criteria) this;
        }

        public Criteria andJsfsbmIsNotNull() {
            addCriterion("JSFSBM is not null");
            return (Criteria) this;
        }

        public Criteria andJsfsbmEqualTo(String value) {
            addCriterion("JSFSBM =", value, "jsfsbm");
            return (Criteria) this;
        }

        public Criteria andJsfsbmNotEqualTo(String value) {
            addCriterion("JSFSBM <>", value, "jsfsbm");
            return (Criteria) this;
        }

        public Criteria andJsfsbmGreaterThan(String value) {
            addCriterion("JSFSBM >", value, "jsfsbm");
            return (Criteria) this;
        }

        public Criteria andJsfsbmGreaterThanOrEqualTo(String value) {
            addCriterion("JSFSBM >=", value, "jsfsbm");
            return (Criteria) this;
        }

        public Criteria andJsfsbmLessThan(String value) {
            addCriterion("JSFSBM <", value, "jsfsbm");
            return (Criteria) this;
        }

        public Criteria andJsfsbmLessThanOrEqualTo(String value) {
            addCriterion("JSFSBM <=", value, "jsfsbm");
            return (Criteria) this;
        }

        public Criteria andJsfsbmLike(String value) {
            addCriterion("JSFSBM like", value, "jsfsbm");
            return (Criteria) this;
        }

        public Criteria andJsfsbmNotLike(String value) {
            addCriterion("JSFSBM not like", value, "jsfsbm");
            return (Criteria) this;
        }

        public Criteria andJsfsbmIn(List<String> values) {
            addCriterion("JSFSBM in", values, "jsfsbm");
            return (Criteria) this;
        }

        public Criteria andJsfsbmNotIn(List<String> values) {
            addCriterion("JSFSBM not in", values, "jsfsbm");
            return (Criteria) this;
        }

        public Criteria andJsfsbmBetween(String value1, String value2) {
            addCriterion("JSFSBM between", value1, value2, "jsfsbm");
            return (Criteria) this;
        }

        public Criteria andJsfsbmNotBetween(String value1, String value2) {
            addCriterion("JSFSBM not between", value1, value2, "jsfsbm");
            return (Criteria) this;
        }

        public Criteria andJsfsmcIsNull() {
            addCriterion("JSFSMC is null");
            return (Criteria) this;
        }

        public Criteria andJsfsmcIsNotNull() {
            addCriterion("JSFSMC is not null");
            return (Criteria) this;
        }

        public Criteria andJsfsmcEqualTo(String value) {
            addCriterion("JSFSMC =", value, "jsfsmc");
            return (Criteria) this;
        }

        public Criteria andJsfsmcNotEqualTo(String value) {
            addCriterion("JSFSMC <>", value, "jsfsmc");
            return (Criteria) this;
        }

        public Criteria andJsfsmcGreaterThan(String value) {
            addCriterion("JSFSMC >", value, "jsfsmc");
            return (Criteria) this;
        }

        public Criteria andJsfsmcGreaterThanOrEqualTo(String value) {
            addCriterion("JSFSMC >=", value, "jsfsmc");
            return (Criteria) this;
        }

        public Criteria andJsfsmcLessThan(String value) {
            addCriterion("JSFSMC <", value, "jsfsmc");
            return (Criteria) this;
        }

        public Criteria andJsfsmcLessThanOrEqualTo(String value) {
            addCriterion("JSFSMC <=", value, "jsfsmc");
            return (Criteria) this;
        }

        public Criteria andJsfsmcLike(String value) {
            addCriterion("JSFSMC like", value, "jsfsmc");
            return (Criteria) this;
        }

        public Criteria andJsfsmcNotLike(String value) {
            addCriterion("JSFSMC not like", value, "jsfsmc");
            return (Criteria) this;
        }

        public Criteria andJsfsmcIn(List<String> values) {
            addCriterion("JSFSMC in", values, "jsfsmc");
            return (Criteria) this;
        }

        public Criteria andJsfsmcNotIn(List<String> values) {
            addCriterion("JSFSMC not in", values, "jsfsmc");
            return (Criteria) this;
        }

        public Criteria andJsfsmcBetween(String value1, String value2) {
            addCriterion("JSFSMC between", value1, value2, "jsfsmc");
            return (Criteria) this;
        }

        public Criteria andJsfsmcNotBetween(String value1, String value2) {
            addCriterion("JSFSMC not between", value1, value2, "jsfsmc");
            return (Criteria) this;
        }

        public Criteria andJeIsNull() {
            addCriterion("JE is null");
            return (Criteria) this;
        }

        public Criteria andJeIsNotNull() {
            addCriterion("JE is not null");
            return (Criteria) this;
        }

        public Criteria andJeEqualTo(BigDecimal value) {
            addCriterion("JE =", value, "je");
            return (Criteria) this;
        }

        public Criteria andJeNotEqualTo(BigDecimal value) {
            addCriterion("JE <>", value, "je");
            return (Criteria) this;
        }

        public Criteria andJeGreaterThan(BigDecimal value) {
            addCriterion("JE >", value, "je");
            return (Criteria) this;
        }

        public Criteria andJeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("JE >=", value, "je");
            return (Criteria) this;
        }

        public Criteria andJeLessThan(BigDecimal value) {
            addCriterion("JE <", value, "je");
            return (Criteria) this;
        }

        public Criteria andJeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("JE <=", value, "je");
            return (Criteria) this;
        }

        public Criteria andJeIn(List<BigDecimal> values) {
            addCriterion("JE in", values, "je");
            return (Criteria) this;
        }

        public Criteria andJeNotIn(List<BigDecimal> values) {
            addCriterion("JE not in", values, "je");
            return (Criteria) this;
        }

        public Criteria andJeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("JE between", value1, value2, "je");
            return (Criteria) this;
        }

        public Criteria andJeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("JE not between", value1, value2, "je");
            return (Criteria) this;
        }

        public Criteria andZsIsNull() {
            addCriterion("ZS is null");
            return (Criteria) this;
        }

        public Criteria andZsIsNotNull() {
            addCriterion("ZS is not null");
            return (Criteria) this;
        }

        public Criteria andZsEqualTo(BigDecimal value) {
            addCriterion("ZS =", value, "zs");
            return (Criteria) this;
        }

        public Criteria andZsNotEqualTo(BigDecimal value) {
            addCriterion("ZS <>", value, "zs");
            return (Criteria) this;
        }

        public Criteria andZsGreaterThan(BigDecimal value) {
            addCriterion("ZS >", value, "zs");
            return (Criteria) this;
        }

        public Criteria andZsGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ZS >=", value, "zs");
            return (Criteria) this;
        }

        public Criteria andZsLessThan(BigDecimal value) {
            addCriterion("ZS <", value, "zs");
            return (Criteria) this;
        }

        public Criteria andZsLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ZS <=", value, "zs");
            return (Criteria) this;
        }

        public Criteria andZsIn(List<BigDecimal> values) {
            addCriterion("ZS in", values, "zs");
            return (Criteria) this;
        }

        public Criteria andZsNotIn(List<BigDecimal> values) {
            addCriterion("ZS not in", values, "zs");
            return (Criteria) this;
        }

        public Criteria andZsBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ZS between", value1, value2, "zs");
            return (Criteria) this;
        }

        public Criteria andZsNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ZS not between", value1, value2, "zs");
            return (Criteria) this;
        }

        public Criteria andHjIsNull() {
            addCriterion("HJ is null");
            return (Criteria) this;
        }

        public Criteria andHjIsNotNull() {
            addCriterion("HJ is not null");
            return (Criteria) this;
        }

        public Criteria andHjEqualTo(BigDecimal value) {
            addCriterion("HJ =", value, "hj");
            return (Criteria) this;
        }

        public Criteria andHjNotEqualTo(BigDecimal value) {
            addCriterion("HJ <>", value, "hj");
            return (Criteria) this;
        }

        public Criteria andHjGreaterThan(BigDecimal value) {
            addCriterion("HJ >", value, "hj");
            return (Criteria) this;
        }

        public Criteria andHjGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("HJ >=", value, "hj");
            return (Criteria) this;
        }

        public Criteria andHjLessThan(BigDecimal value) {
            addCriterion("HJ <", value, "hj");
            return (Criteria) this;
        }

        public Criteria andHjLessThanOrEqualTo(BigDecimal value) {
            addCriterion("HJ <=", value, "hj");
            return (Criteria) this;
        }

        public Criteria andHjIn(List<BigDecimal> values) {
            addCriterion("HJ in", values, "hj");
            return (Criteria) this;
        }

        public Criteria andHjNotIn(List<BigDecimal> values) {
            addCriterion("HJ not in", values, "hj");
            return (Criteria) this;
        }

        public Criteria andHjBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("HJ between", value1, value2, "hj");
            return (Criteria) this;
        }

        public Criteria andHjNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("HJ not between", value1, value2, "hj");
            return (Criteria) this;
        }

        public Criteria andZyIsNull() {
            addCriterion("ZY is null");
            return (Criteria) this;
        }

        public Criteria andZyIsNotNull() {
            addCriterion("ZY is not null");
            return (Criteria) this;
        }

        public Criteria andZyEqualTo(String value) {
            addCriterion("ZY =", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyNotEqualTo(String value) {
            addCriterion("ZY <>", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyGreaterThan(String value) {
            addCriterion("ZY >", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyGreaterThanOrEqualTo(String value) {
            addCriterion("ZY >=", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyLessThan(String value) {
            addCriterion("ZY <", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyLessThanOrEqualTo(String value) {
            addCriterion("ZY <=", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyLike(String value) {
            addCriterion("ZY like", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyNotLike(String value) {
            addCriterion("ZY not like", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyIn(List<String> values) {
            addCriterion("ZY in", values, "zy");
            return (Criteria) this;
        }

        public Criteria andZyNotIn(List<String> values) {
            addCriterion("ZY not in", values, "zy");
            return (Criteria) this;
        }

        public Criteria andZyBetween(String value1, String value2) {
            addCriterion("ZY between", value1, value2, "zy");
            return (Criteria) this;
        }

        public Criteria andZyNotBetween(String value1, String value2) {
            addCriterion("ZY not between", value1, value2, "zy");
            return (Criteria) this;
        }

        public Criteria andBzIsNull() {
            addCriterion("BZ is null");
            return (Criteria) this;
        }

        public Criteria andBzIsNotNull() {
            addCriterion("BZ is not null");
            return (Criteria) this;
        }

        public Criteria andBzEqualTo(String value) {
            addCriterion("BZ =", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzNotEqualTo(String value) {
            addCriterion("BZ <>", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzGreaterThan(String value) {
            addCriterion("BZ >", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzGreaterThanOrEqualTo(String value) {
            addCriterion("BZ >=", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzLessThan(String value) {
            addCriterion("BZ <", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzLessThanOrEqualTo(String value) {
            addCriterion("BZ <=", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzLike(String value) {
            addCriterion("BZ like", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzNotLike(String value) {
            addCriterion("BZ not like", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzIn(List<String> values) {
            addCriterion("BZ in", values, "bz");
            return (Criteria) this;
        }

        public Criteria andBzNotIn(List<String> values) {
            addCriterion("BZ not in", values, "bz");
            return (Criteria) this;
        }

        public Criteria andBzBetween(String value1, String value2) {
            addCriterion("BZ between", value1, value2, "bz");
            return (Criteria) this;
        }

        public Criteria andBzNotBetween(String value1, String value2) {
            addCriterion("BZ not between", value1, value2, "bz");
            return (Criteria) this;
        }

        public Criteria andShIsNull() {
            addCriterion("SH is null");
            return (Criteria) this;
        }

        public Criteria andShIsNotNull() {
            addCriterion("SH is not null");
            return (Criteria) this;
        }

        public Criteria andShEqualTo(String value) {
            addCriterion("SH =", value, "sh");
            return (Criteria) this;
        }

        public Criteria andShNotEqualTo(String value) {
            addCriterion("SH <>", value, "sh");
            return (Criteria) this;
        }

        public Criteria andShGreaterThan(String value) {
            addCriterion("SH >", value, "sh");
            return (Criteria) this;
        }

        public Criteria andShGreaterThanOrEqualTo(String value) {
            addCriterion("SH >=", value, "sh");
            return (Criteria) this;
        }

        public Criteria andShLessThan(String value) {
            addCriterion("SH <", value, "sh");
            return (Criteria) this;
        }

        public Criteria andShLessThanOrEqualTo(String value) {
            addCriterion("SH <=", value, "sh");
            return (Criteria) this;
        }

        public Criteria andShLike(String value) {
            addCriterion("SH like", value, "sh");
            return (Criteria) this;
        }

        public Criteria andShNotLike(String value) {
            addCriterion("SH not like", value, "sh");
            return (Criteria) this;
        }

        public Criteria andShIn(List<String> values) {
            addCriterion("SH in", values, "sh");
            return (Criteria) this;
        }

        public Criteria andShNotIn(List<String> values) {
            addCriterion("SH not in", values, "sh");
            return (Criteria) this;
        }

        public Criteria andShBetween(String value1, String value2) {
            addCriterion("SH between", value1, value2, "sh");
            return (Criteria) this;
        }

        public Criteria andShNotBetween(String value1, String value2) {
            addCriterion("SH not between", value1, value2, "sh");
            return (Criteria) this;
        }

        public Criteria andIdJbdIsNull() {
            addCriterion("ID_JBD is null");
            return (Criteria) this;
        }

        public Criteria andIdJbdIsNotNull() {
            addCriterion("ID_JBD is not null");
            return (Criteria) this;
        }

        public Criteria andIdJbdEqualTo(String value) {
            addCriterion("ID_JBD =", value, "idJbd");
            return (Criteria) this;
        }

        public Criteria andIdJbdNotEqualTo(String value) {
            addCriterion("ID_JBD <>", value, "idJbd");
            return (Criteria) this;
        }

        public Criteria andIdJbdGreaterThan(String value) {
            addCriterion("ID_JBD >", value, "idJbd");
            return (Criteria) this;
        }

        public Criteria andIdJbdGreaterThanOrEqualTo(String value) {
            addCriterion("ID_JBD >=", value, "idJbd");
            return (Criteria) this;
        }

        public Criteria andIdJbdLessThan(String value) {
            addCriterion("ID_JBD <", value, "idJbd");
            return (Criteria) this;
        }

        public Criteria andIdJbdLessThanOrEqualTo(String value) {
            addCriterion("ID_JBD <=", value, "idJbd");
            return (Criteria) this;
        }

        public Criteria andIdJbdLike(String value) {
            addCriterion("ID_JBD like", value, "idJbd");
            return (Criteria) this;
        }

        public Criteria andIdJbdNotLike(String value) {
            addCriterion("ID_JBD not like", value, "idJbd");
            return (Criteria) this;
        }

        public Criteria andIdJbdIn(List<String> values) {
            addCriterion("ID_JBD in", values, "idJbd");
            return (Criteria) this;
        }

        public Criteria andIdJbdNotIn(List<String> values) {
            addCriterion("ID_JBD not in", values, "idJbd");
            return (Criteria) this;
        }

        public Criteria andIdJbdBetween(String value1, String value2) {
            addCriterion("ID_JBD between", value1, value2, "idJbd");
            return (Criteria) this;
        }

        public Criteria andIdJbdNotBetween(String value1, String value2) {
            addCriterion("ID_JBD not between", value1, value2, "idJbd");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}